Pivot analysis method using condition group

ABSTRACT

A pivot analysis method using a condition group is applicable to a front end processing device and includes the following steps. A file name processing interface is presented according to a plurality of file names. A file name selection value is received via a first sub interface of the file name processing interface. A range setting value is received via a second sub interface of the file name processing interface. A file name computing value is received via a third sub interface of the file name processing interface. A file name processing value generated by integrating the file name selection value, the file name range setting value and the file name computing value, is outputted. A multidimensional array is received to present a pivot analysis table.

TECHNICAL FIELD

The disclosure relates to a pivot analysis method using a conditiongroup, more particularly to a pivot analysis method that an on-lineanalytical processing (OLAP) system selects data by using a conditiongroup.

BACKGROUND

Typical applications of on-line analytical processing (OLAP) systemrequire the fast access of multidimensional data. Data warehouseimplemented in the OLAP system is a central database used for storingimportant data collected by various business systems belonging to acompany. The central database of the data warehouse generally connectsto a main server in the OLAP system.

The OLAP system enables users to acquire data in various dimensionseasily and selectively and to review a table established according tothe acquired data. For example, when data analysis is requested, theOLAP system provides a trail balance presenting sales informationassociated with all products sold in a certain electronic company forcomparison. For instance, the sales information includes the profit dataof a mobile phone on a current month and a previous month and the salesvolumes of various mobile phones in the same period.

For a conventional OLAP system, it requires data warehouse tools togenerate a statement for the aforementioned comparison results. The datawarehouse tools organize data values in a form in a relational databaseinto a cube having a multidimensional structure, and then generate apivot analysis table according to the dimensionality, attributes andstructure of cube.

However, such a pivot analysis table only shows attributes of theselected data values for comparison, where the conventional OLAP systemhave not processed the dimensionality, attributes and structure of theselected data values. To process the dimensionality, attributes andstructure of data values additionally, extra data tables are required.After the dimensionality, attributes and structure of data values areprocessed, the conventional OLAP system outputs another pivot analysistable according to the processed dimensionality, attributes andstructure of data values. This procedure is very complicated, requiresmore storage space and has errors easily.

Therefore, a more efficient pivot analysis method is required in the artto provide a fast way between data processing and data presentation andto present computing relationships and comparison relationships amongdata values.

SUMMARY

A pivot analysis method using a condition group according to anembodiment of the disclosure is applicable to a front end processingdevice and includes the following steps. A file name processinginterface is presented according to file names. A file name selectionvalue is received via a first sub interface of the file name processinginterface. A range setting value is received via a second sub interfaceof the file name processing interface. A file name computing value isreceived via a third sub interface of the file name processinginterface. A file name processing value generated by integrating thefile name selection value, the file name range setting value and thefile name computing value is outputted. A multidimensional array isreceived, and then a pivot analysis table is presented according to themultidimensional array.

A pivot analysis method using a condition group according to anembodiment of the disclosure is applicable to a back end processingdevice and includes the following steps. A file name processing value isreceived. Data values in a database are acquired according to the filename processing value. A multidimensional array is generated accordingto the data values and the file name processing value, and is outputted.

A pivot analysis method using a condition group according to anembodiment of the disclosure is applicable to a front end processingdevice and a back end processing device and includes the followingsteps. File names in a database are outputted from the back endprocessing device to the front end processing device. The file names arereceived by the front end processing device. A file name processinginterface is presented by the front end processing device according tothe file names. A file name selection value is received through a firstsub interface of the file name processing interface by the front endprocessing device. A range setting value is received through a secondsub interface of the file name processing interface by the front endprocessing device. A file name computing value is received through athird sub interface of the file name processing interface by the frontend processing device. A file name processing value is outputted fromthe front end processing device to the back end processing device, andthe file name processing value is generated by integrating the file nameselection value, the file name range setting value and the file namecomputing value. A file name processing value is received from the frontend processing device by the back end processing device. Data values inthe database are acquired according the file name processing value bythe back end processing device. A multidimensional array is generatedaccording to the data values and the file name processing value by theback end processing device. The multidimensional array is outputted fromthe back end processing device to the front end processing device. Themultidimensional array is received by the front end processing device. Apivot analysis table is presented according to the multidimensionalarray by the front end processing device.

BRIEF DESCRIPTION OF THE DRAWINGS

The present disclosure will become more fully understood from thedetailed description given herein below for illustration only and thusdoes not limit the present disclosure, wherein:

FIG. 1 is a schematic diagram of a pivot analysis system using acondition group according to an embodiment of the disclosure;

FIG. 2 and FIG. 3 show a flowchart of a pivot analysis method using acondition group according to an embodiment of the disclosure;

FIG. 4A and FIG. 4B are schematic diagrams of setting a file nameselection value in a first sub interface according to an embodiment ofthe disclosure;

FIG. 5 is a schematic diagram of a pivot analysis table corresponding tothe file name selection value set in FIG. 4A and FIG. 4B according to anembodiment of the disclosure;

FIG. 6A and FIG. 6B are schematic diagrams of setting a file name rangesetting value in a second sub interface according to an embodiment ofthe disclosure;

FIG. 7 is a schematic diagram of a pivot analysis table corresponding tothe file name range setting value set in FIG. 6A and FIG. 6B accordingto an embodiment of the disclosure;

FIG. 8 is a schematic diagram of setting a file name range setting valuein a second sub interface according to an embodiment of the disclosure;

FIG. 9 is a schematic diagram of a pivot analysis table corresponding tothe file name range setting value set in FIG. 8 according to anembodiment of the disclosure;

FIG. 10 is a schematic diagram of setting a file name computing value ina third sub interface according to an embodiment of the disclosure;

FIG. 11 is a schematic diagram of a pivot analysis table correspondingto the file name computing value set in FIG. 10 according to anembodiment of the disclosure;

FIG. 12 is a schematic diagram of a pivot analysis system using acondition group according to an embodiment of the disclosure;

FIG. 13 is a schematic diagram of setting file name processing valuesaccording to an embodiment of the disclosure; and

FIG. 14 is a schematic histogram corresponding to the file nameprocessing values selected in FIG. 13 according to an embodiment of thedisclosure.

DETAILED DESCRIPTION

In the following detailed description, for purposes of explanation,numerous specific details are set forth in order to provide a thoroughunderstanding of the disclosed embodiments. It will be apparent,however, that one or more embodiments may be practiced without thesespecific details. In other instances, well-known structures and devicesare schematically shown in order to simplify the drawing.

FIG. 1 is a schematic diagram of a pivot analysis system using acondition group according to an embodiment of the disclosure. A pivotanalysis system 1 includes a front end processing device 10, a back endprocessing device 20 and a database 30. The front end processing device10 connects to the back end processing device 20 through, for example, anetwork. The back end processing device 20 connects to the database 30through, for example, the network.

The database 30 is, for example, a relational database. The database 30stores and arranges a plurality of file names and a plurality of datavalues, and each file name corresponds to one or more data values. Forexample, the file name is Color, and the data values corresponding tothe file name of Color can be Red, Green and Yellow. The data values arein a multidimensional and hierarchical form. The back end processingdevice 20, e.g. an OLAP system server, includes a processing unit 200.In this and some embodiments, the database 30 can be built in the backend processing device 20.

The front end processing device 10 includes a file name processinginterface 100. The front end processing device 10 can be, for example, atable computer or a notebook. For example, the file name processinginterface 100 is a user interface using windows in web page protocol.The file name processing interface 100 includes a first sub interface1000, a second sub interface 1001 and a third sub interface 1002. Thefirst sub interface 1000 is used for selecting one of the file names andselecting secondary file names which corresponding to the selected filename, thereby obtaining a file name selection value. Secondary filenames are more accurate search results belonging to the selected filename. The second sub interface 1001 is used for selecting one of thefile names and setting ranges of data values corresponding to theselected file name, thereby obtaining a file name range setting value.The third sub interface 1002 is used for selecting at least two of thefile names and setting a commuting relationship between data values ofthe selected file names. The first sub interface 1000, the second subinterface 1001 and the third sub interface 1002 are, for example, windowoperation interfaces. The detailed operation of the pivot analysissystem 1 is described as follows.

Refer to FIG. 1 and to FIG. 2 and FIG. 3 illustrating a pivot analysismethod using a condition group according to an embodiment of thedisclosure. Firstly, the back end processing device 20 outputs aplurality of file names stored in the database 30 (step S200). In otherwords, the back end processing device 20 connected to the database 30acquires the file names from the database 30 and outputs the acquiredfile names to the front end processing device 10. Each file namecorresponds to at least one data value.

After receiving the file names (step S202), the front end processingdevice 10 shows the file name processing interface 100 according to thereceived file names (step S204). Through the first sub interface 1000,the second sub interface 1001 and the third sub interface 1002 in theshown file name processing interface 100, the front end processingdevice 10 respectively acquires a file name selection value, a file namerange setting value and a file name computing value (step S206). Whenthe desired file name is selected via the first sub interface 1000, thefront end processing device 10 receives a file name selection value viathe first sub interface 1000. When ranges of data values correspondingto the selected file name is set via the second sub interface 1001, thefront end processing device 10 receives a file name range setting valuecorresponding to the selected file name, via the second sub interface1001. When computing relationships between data values corresponding tothe selected at least two file names are set via the third sub interface1002, the front end processing device 10 obtains a file name computingvalue corresponding to the selected file names, via the third subinterface 1002. The file name computing value includes a columncomputing result, a row computing result and a percentage which are setaccording to the file names.

In one embodiment, the first sub interface 1000, the second subinterface 1001 and the third sub interface 1002 can be set independentlyand discontinuously for obtaining their setting result. When one of thefirst sub interface 1000, the second sub interface 1001 and the thirdsub interface 1002 is set, corresponding one of the file name selectionvalue, the file name range setting value and the file name computingvalue will be obtained. In one embodiment, the first sub interface 1000,the second sub interface 1001 and the third sub interface 1002 can beset dependently. When more than one of the first sub interface 1000, thesecond sub interface 1001 and the third sub interface 1002 are setcontinuously, corresponding ones of the file name selection value, thefile name range setting value and the file name computing value will beobtained.

After receiving the file name selection value, the file name rangesetting value and the file name computing value, the front endprocessing device 10 integrates the file name selection value, the filename range setting value and the file name computing value into a filename processing value and outputs the file name selection value to theback end processing device 20 (step S208). In the case of setting thefirst sub interface 1000, the second sub interface 1001 and the thirdsub interface 1002 independently, one of the file name selection value,the file name range setting value and the file name computing value isobtained according to the current setting, and the rest of the file nameselection value, the file name range setting value and the file namecomputing value are obtained from the database 30. For instance, thefile name selection value is obtained according to the current setting,and the file name range setting value and the file name computing valuewhich are set in advance and stored in the database 30 are obtained fromthe database 30. In the case of setting the first sub interface 1000,the second sub interface 1001 and the third sub interface 1002dependently, the file name selection value, the file name range settingvalue and the file name computing value have to be obtained one by oneaccording to the current setting. For instance, the front end processingdevice 10 receives the file name selection value, the file name rangesetting value and the file name computing value one by one in real timeafter they are set successively.

When the back end processing device 20 receives the file name processingvalue outputted by the front end processing device 10 (step S210), theprocessing unit 200 in the back end processing device 20 acquires datavalues from the database 30 according to the file name processing value(step S212). Then, the processing unit 200 generates a multidimensionalarray according to the acquired data values and the file name processingvalue (step S214), and the back end processing device 20 outputs themultidimensional array to the front end processing device 10 (stepS216). The multidimensional array integrates selected data values into amatrix data structure which having more than one dimension.

After receiving the multidimensional array from the back end processingdevice 20 (step S218), the front end processing device 10 shows a pivotanalysis table according to the multidimensional array (step S220). Inthis and some embodiments, the front end processing device 10 furthershows a histogram according to the multidimensional array according tovarious requirements and settings.

Additionally, the file name processing value outputted from the frontend processing device 10 to the back end processing device 20 can berecorded in a storage unit, e.g. a non-volatile memory, so that the backend processing device 20 can use the recorded file name processing valuerepeatedly. In an embodiment, the file name processing value is recordedwith multidimensional expressions (MDX). The MDX of the file nameprocessing value is generated by the back end processing device 20automatically when the front end processing device 10 outputs the filename processing value to the back end processing device 20. The detailedsettings of the file name selection value, the file name range settingvalue, the file name computing value and the file name processing valueare described as follows.

FIG. 4A and FIG. 4B are schematic diagrams of setting a file nameselection value in a first sub interface according to an embodiment ofthe disclosure. A first sub interface 40 is the same as the first subinterface 1000 in FIG. 1. The first sub interface 40 includes a filename list 401 and a secondary file name list 402. The file name list 401shows a plurality of file names, e.g. Product 1 to Product 7, forselection. For instance, file names in the database are in ahierarchical structure. When one file name is selected, the secondaryfile name list 402 will show secondary file names, e.g. Color 1 to Color3, Type 1 to Type 3 and Size 1 to Size 3, for selection.

In FIG. 4A, assume that a file name 403 of Product 1 in the file namelist 401 is selected, and that a secondary file name of Color 1 in asecondary file name option list 4021 and a secondary file name of Type 2in a secondary file name option list 4022 in the secondary file namelist 402 are selected. A first setting condition is completed.Similarly, in FIG. 4B, assume that the secondary file name of Color 1and a secondary file name of Type 3 are selected. A second settingcondition is completed. The first setting condition in FIG. 4A and thesecond setting condition in FIG. 4B are integrated into a file nameselection value.

Assume that a file name range setting value and a file name computingvalue are preset. According to a file name processing value generated byintegrating the file name selection value, the preset file name rangesetting value and the preset file name computing value, a pivot analysistable 50 as shown in FIG. 5 can be established.

In FIG. 5, the pivot analysis table 50 shows a pivot analysis field 501and a pivot analysis field 502, and shows data values selected accordingto the file name selection value. The pivot analysis field 501corresponds to the selected result in the secondary file name optionlist 4021 and 4022 in FIG. 4A, and the pivot analysis field 502corresponds to the selected result in the secondary file name optionlist 4021 and 4022 in FIG. 4B. Therefore, desired data values, e.g. thesales volume and order volume, of the pivot analysis fields 501 and 502corresponding to the selected file name 403 can be known through thepivot analysis table 50.

FIG. 6A and FIG. 6B are schematic diagrams of setting a file name rangesetting value in a second sub interface according to an embodiment ofthe disclosure. A second sub interface 60 is the same as the second subinterface 1001 in FIG. 1. The second sub interface 60 includes a filename list 601, a range setting list 602 and a time period setting list603. The file name list 601 shows file names as the same as that in FIG.4A and FIG. 4B. When one file name is selected, the range setting list602 correspondingly shows range options, e.g. Range 1 to Range 3, forselection and insertion. Each selection range has an upper limit valueand a lower limit value. Meanwhile the time period setting list 603correspondingly shows empty fields for inserting an upper limit valueand a lower limit value of a desire time period.

In FIG. 6A, assume that a filed name 604 of “Product 1” in the file namelist 601 is selected, that a range option 6021 of Range 1 representingsales volume is selected and is set at 0 to 255, and that the selectedtime period setting list 603 is selected and is set at AD 2011 to 2012.Subsequently, in FIG. 6B, a range option 6022 of Range 2 representingorder volume is selected and is set at 100 to 200, and the selected timeperiod setting list 603 is also set at AD 2011 to 2012. The settings inthe range setting list 602 and the settings in the time period settinglist 603 in FIG. 6A and FIG. 6B are integrated into a file name rangesetting value which has an upper limit value and a lower limit valuecorresponding to the settings.

In this and some embodiments, the ranges relative to the range settinglist 602 can be preset for direct selection, and the time period settinglist 603 also can provide a plurality of preset time periods for directselection.

Assume that the file name selection value and the file name computingvalue are preset. According to a file name processing value generated byintegrating the preset file name selection value, the file name rangesetting value and the preset file name computing value, a pivot analysistable 70 as shown in FIG. 7 can be established.

In FIG. 7, the pivot analysis table 70 shows a pivot analysis field 701,a pivot analysis field 702, a pivot analysis field 703, and data valuesselected according to the file name range setting value in FIG. 6A andFIG. 6B. The pivot analysis field 701 corresponds to the setting in thetime period setting list 603. The pivot analysis field 702 correspondsto the setting in the range setting list 602 in FIG. 6A. The pivotanalysis field 703 corresponds to the setting in the range setting list602 in FIG. 6B.

Therefore, desired data values, e.g. the sales volume and order volume,of the pivot analysis fields 702 and 703 corresponding to the selectedfile name 604 can be known through the pivot analysis table 70.

FIG. 8 is a schematic diagram of setting a file name range setting valuein a second sub interface according to an embodiment of the disclosure.A second sub interface 61 is the same as the second sub interface 1001in FIG. 1. Difference between the second sub interface 61 and the secondsub interface 60 in FIG. 6A to FIG. 6B is that a range setting list 605in the second sub interface 61 shows range options, e.g. Range 1 toRange 3, of time ranges (the file name range setting value) whichspecifying specific sales volumes and order volumes. The time range isset by selecting information in a calendar or pull down menus or byinserting desired information directly.

When the file name 604 of “Product 1” in the file name list 601 isselected, the corresponding range setting list 605 will presented.Assume that each time range is preset for selection, and that a timerange setting 6051 of “Range 1”, a time range setting 6052 of “Range 2”and a time range setting 6053 of “Range 3” in the range setting list 605are successively selected. The settings in the range setting list 605are integrated into a file name range setting value.

Assume that the file name selection value and the file name computingvalue are preset. According to a file name processing value generated byintegrating the preset file name selection value, the file name rangesetting value and the preset file name computing value, a pivot analysistable 71 as shown in FIG. 9 can be established.

In FIG. 9, the pivot analysis table 71 shows a pivot analysis field 704,a pivot analysis field 705, a pivot analysis field 706, and data valuesselected according to the file name range setting value in FIG. 8. Thepivot analysis field 704 corresponds to the time range setting 6051. Thepivot analysis field 705 corresponds to the time range setting 6052. Thepivot analysis field 706 corresponds to the time range setting 6053.

Therefore, desired data values, e.g. the sales volume and order volume,of the pivot analysis fields 704 to and 706 corresponding to theselected file name 604 can be known through the pivot analysis table 71.

FIG. 10 is a schematic diagram of setting a file name computing value ina third sub interface according to an embodiment of the disclosure. Athird sub interface 80 is the same as the third sub interface 1002 inFIG. 1. The third sub interface 80 includes a file name list 801 and acalculation input list 802. The file name list 801 shows file names asthe same as that in FIGS. 4A and 4B. The calculation input list 802shows calculation equation options corresponding to selected file namesin file name list 801, for selection and insertion. The calculationequation of each calculation equation option utilizes the data values ofthe selection file names as parameters, so as to set the computingrelationship, e.g. addition, subtraction or percentage, between theselected file names.

Assume that a file name 803 of “Product 1,” a file name 804 of “Product2,” a file name 805 of “Product 3,” a file name 806 of “Product 5” and afile name 807 of “Product 6” are selected. Calculation equations can beinserted into the calculation input list 802 according to variousrequirements. Assume that a calculation equation of “P1+P2−P3”indicating a sales volume of the file name 803 plus a sales volume ofthe file name 804 minus a sales volume of the file name 805, is insertedinto a selected calculation equation option 8021 of Cal 1, and that acalculation equation of P3*P5+P6 indicating the sales volume of the filename 805 times a sales volume of the file name 806 plus a sales volumeof the file name 807, is inserted into a selected calculation equationoption 8022 of Cal 2. P1 represents the data value of the file name 803of “Product 1”, P2 represents the data value 804 of the file name of“Product 2,” and the rest can be deduced analogically. The setting inthe calculation input list 802 is integrated into a file name computingvalue.

In a typical table, file names can be arranged in column or in row.Therefore, the third sub interface 80 can perform column computing onthe file names in column, or perform row computing on the file names inrow. In some embodiments, in order to compare data values moreconveniently, percentage can be inserted into the calculation equation,e.g. P1*80%+P2*10%+P3*10%.

In this and some embodiments, the calculation equation in eachcalculation equation option can be preset for direct selection.

Assume that the file name selection value and the file name rangesetting value are preset. According to a file name processing valuegenerated by integrating the preset file name selection value, thepreset file name range setting value and the file name computing value,a pivot analysis table 90 as shown in FIG. 10 can be established.

In FIG. 11, the pivot analysis table 90 shows a pivot analysis field 901of Cal 1 and a pivot analysis field 902 of Cal 2, and shows data values,e.g. the sales volume and order volume, selected according to the filename computing value. The pivot analysis field 901 corresponds to thecalculation equation option 8021, and the pivot analysis field 902corresponds to the calculation equation option 8022.

Therefore, the computing relationship between desired data values of thepivot analysis field 901 corresponding to the selected file names 803,804 and 805, and the computing relationship between desired data valuesof the pivot analysis field 902 corresponding to the selected file names805, 806 and 807 can be known through the pivot analysis table 90.

On the other hand, the file name processing interface 100 in FIG. 1further includes a setting selection interface 1003 as shown in FIG. 12.The setting selection interface 1003 shows various stored file nameprocessing values for selection according various requirements. Thedetailed operation of the setting selection interface 1003 is describedas follows.

FIG. 13 is a schematic diagram of setting file name processing valuesaccording to an embodiment of the disclosure. A setting selectioninterface 110 is the same as the setting selection interface 1003 InFIG. 12. The setting selection interface 110 shows a file name list 1101and a setting selection list 1102. The file name list 1101 is the sameas the file name list 401 in FIG. 4A and FIG. 4B. When a file name 1103of Product 1 is selected, corresponding setting options, e.g. SavedSetting 1 to Saved Setting 3, will be shown in the setting selectionlist 1102 for selection. Each setting option corresponds to one storedfile name processing value.

Assume that setting options of Saved Setting 1, Saved Setting 2 andSaved setting 3 are selected. A histogram 120 corresponding to theselected setting options is established as shown in FIG. 14. In FIG. 14,the abscissa represents file name processing values, and the ordinaterepresents sales volumes. Through the histogram 120, multidimensionalinformation of the selected file name 110 of Product 1 can be known.

In an embodiment of the disclosure, a pivot analysis table can alsoestablished according to a file name processing value generated byintegrating the file name selection value set in FIG. 4A and FIG. 4B,the file name range setting value set in FIG. 6A and FIG. 6B, and thefile name computing value set in FIG. 10.

In the disclosure, the content of the pivot analysis table and thecontent of the histogram can be arranged according to variousrequirements.

In the pivot analysis method using a condition group, a pivot analysistable and/or a histogram can be outputted according to the file nameprocessing value after the file name processing value is set by the filename processing interface in the front end processing device. The filename processing value includes the file name selection value, the filename range setting value and the file name computing value, and is usedfor selecting and processing data values in the database. The file nameselection value is used for selecting desired file names. The file namerange setting value is used for setting ranges of data valuescorresponding to the desired file names. The file name computing valueis used for setting the computing relationship between data values ofthe desired file names.

Moreover, the file name processing value can be recorded in the back endprocessing device for repeated use. In this way, a user can set a newfile name processing value or use the stored file name processing valueto obtain a desired pivot analysis table, thereby making data analysismore convenient.

What is claimed is:
 1. A pivot analysis method using a condition group,being applicable to a front end processing device, and comprising:presenting a file name processing window on the front end processingdevice according to a plurality of file names received from an OLAPserver; receiving a file name selection value via a first sub window ofthe file name processing window; receiving a file name range settingvalue via a second sub window of the file name processing window;receiving a file name computing value via a third sub interface of thefile name processing interface; outputting a file name processing valueto the OLAP server, the file name processing value is generated byintegrating the file name selection value, the file name range settingvalue and the file name computing value; receiving a multidimensionalarray from the OLAP server; and presenting a pivot analysis tableaccording to the multidimensional array; wherein the first sub window,the second sub window and the third sub window are graphical interfaces,and each of the first sub window, the second sub window and the thirdsub window includes a file name list showing the plurality of file namesselectable.
 2. The pivot analysis method according to claim 1, whereinthe file names are used for representing a plurality of data values. 3.The pivot analysis method according to claim 1, wherein the file nameselection value comprises a part of the file names.
 4. The pivotanalysis method according to claim 1, wherein the file name rangesetting value comprises an upper limit value and a lower limit valuewhich are set according to the file names.
 5. The pivot analysis methodaccording to claim 1, wherein the file name computing value comprises acolumn computing result, a row computing result and a percentage whichare set according to the file names.
 6. The pivot analysis methodaccording to claim 1, further comprising: presenting a histogramaccording to the multidimensional array.
 7. A pivot analysis methodusing a condition group, being applicable to a back end processingdevice, and comprising: receiving a file name processing value;acquiring a plurality of data values in a database according to the filename processing value when an existing record corresponding to the filename processing value is not stored in the back end processing device;generating a multidimensional array according to the data values and thefile name processing value when the existing record corresponding to thefile name processing value is not stored in the back end processingdevice; generating the multidimensional array according to the existingrecord when the existing record corresponding to the file nameprocessing value is stored in the back end processing device; andoutputting the multidimensional array; wherein the back end processingdevice is an OLAP server, the file name processing value is generated byintegrating a file name selection value, a file name range setting valueand a file name computing value, the file name selection value isreceived by a first sub window, the file name range setting value isreceived by a second sub window, the file name computing value isreceived by a third sub window, the first sub window, the second subwindow and the third sub window are graphical interfaces, and each ofthe first sub window, the second sub window and the third sub windowincludes a file name list showing the plurality of file namesselectable.
 8. The pivot analysis method according to claim 7, whereinthe back end processing device connects to the database.
 9. The pivotanalysis method according to claim 7, wherein the data values are in amultidimensional and hierarchical form.
 10. A pivot analysis methodusing a condition group, being applicable to a front end processingdevice and a back end processing device, and comprising: outputting aplurality of file names in a database to the front end processing deviceby the back end processing device; receiving the file names via thefront end processing device; presenting a file name processing window onthe front end processing device according to the file names via thefront end processing device; receiving a file name selection value bythe front end processing device through a first sub window of the filename processing window; receiving a range setting value by the front endprocessing device through a second sub window of the file nameprocessing window; receiving a file name computing value by the frontend processing device through a third sub window of the file nameprocessing window; outputting a file name processing value to the backend processing device by the front end processing device, wherein thefile name processing value is generated by integrating the file nameselection value, the file name range setting value and the file namecomputing value; receiving a file name processing value from the frontend processing device by the back end processing device; acquiring aplurality of data values in the database according to the file nameprocessing value via the back end processing device when an existingrecord corresponding to the file name processing value is not stored inthe back end processing device; generating a multidimensional arrayaccording to the data values and the file name processing value via theback end processing device when the existing record corresponding to thefile name processing value is not stored in the back end processingdevice; generating the multidimensional array according to the existingrecord when the existing record corresponding to the file nameprocessing value is stored in the back end processing device; and;outputting the multidimensional array from the back end processingdevice to the front end processing device; receiving themultidimensional array via the front end processing device; andpresenting a pivot analysis table according to the multidimensionalarray via the front end processing device; wherein the back endprocessing device is an OLAP server, the first sub window, the secondsub window and the third sub window are graphical interfaces, and eachof the first sub window, the second sub window and the third sub windowincludes a file name list showing the plurality of file namesselectable.
 11. The pivot analysis method according to claim 10, whereinthe file name processing value is stored in the back end processingdevice.